SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].DepartamentosSelectCommandByDepartamento
(
	@DEPARTAMENTO varchar(50)
)
AS
	SET NOCOUNT ON;
SELECT        ID, DEPARTAMENTO, ACTIVO
FROM            DEPARTAMENTOS
WHERE        (DEPARTAMENTO LIKE '%' + @DEPARTAMENTO + '%')
GO
